RetailShoppingTripType

Entity Definition

Logical Name : RetailShoppingTripType
Physical Name : CO_RTL_SHPPG_TRP_TYP

A retailer defined classification for a customer/consumer shipping trip purpose. This is used when anlyzing and classifying retail transactions to evaluate whether the consumer's purpose is: MAJOR_STOCKUP FILL-IN QUICKTRIP The idea of this classification is to characterize retail transactions in a way that offers insights into how critical a role promotional markdowns, advertising, store layout and other retail experiential factors paly in modifying consumer behavior. For example consumers intereste in quick trips are less likely to look for deals. On the other hand major stockup trips will involve large quantities and typcially consumers will be looking for discounts.

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
RetailShoppingTripTypeCode (PK)	A code designating the purpose of the shopping trip that is related to a RetailTransaction. Examples: QUICKSTOP FILLIN STOCKUP	CD_RTL_SHPPG_TRP_TYP	Code	varchar(20)
RetailShoppingTripTypeDescription	Business description of this RetailShoppingTripType.	DE_RTL_SHPPG_TRP_TYP	DescriptionShort	varchar(255)

Relationships

Parent Entity	Verb Phrase	Child Entity
RetailShoppingTripType	defines purpose of	RetailTransaction

Logical Views containing RetailShoppingTripType

Logical View
Logical 02300 - Retail Transaction - Macro View